﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ContactsDS" targetNamespace="http://tempuri.org/ContactsDS.xsd" xmlns:mstns="http://tempuri.org/ContactsDS.xsd" xmlns="http://tempuri.org/ContactsDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AdventureWorks_DataConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AdventureWorks_DataConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.AdventureWorksProvider.Properties.Settings.GlobalReference.Default.AdventureWorks_DataConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContactTableAdapter" GeneratorDataComponentClassName="ContactTableAdapter" Name="Contact" UserDataComponentName="ContactTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AdventureWorks_DataConnectionString (Settings)" DbObjectName="Person.Contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Person].[Contact] WHERE (([ContactID] = @Original_ContactID) AND ([NameStyle] = @Original_NameStyle) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ([FirstName] = @Original_FirstName) AND ((@IsNull_MiddleName = 1 AND [MiddleName] IS NULL) OR ([MiddleName] = @Original_MiddleName)) AND ([LastName] = @Original_LastName) AND ((@IsNull_Suffix = 1 AND [Suffix] IS NULL) OR ([Suffix] = @Original_Suffix)) AND ((@IsNull_EmailAddress = 1 AND [EmailAddress] IS NULL) OR ([EmailAddress] = @Original_EmailAddress)) AND ([EmailPromotion] = @Original_EmailPromotion) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ([PasswordHash] = @Original_PasswordHash) AND ([PasswordSalt] = @Original_PasswordSalt) AND ([rowguid] = @Original_rowguid) AND ([ModifiedDate] = @Original_ModifiedDate))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Person].[Contact] ([NameStyle], [Title], [FirstName], [MiddleName], [LastName], [Suffix], [EmailAddress], [EmailPromotion], [Phone], [PasswordHash], [PasswordSalt], [AdditionalContactInfo], [rowguid], [ModifiedDate], [AdditionalData]) VALUES (@NameStyle, @Title, @FirstName, @MiddleName, @LastName, @Suffix, @EmailAddress, @EmailPromotion, @Phone, @PasswordHash, @PasswordSalt, @AdditionalContactInfo, @rowguid, @ModifiedDate, @AdditionalData);
SELECT TOP (200) ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate, AdditionalData FROM Person.Contact WHERE (ContactID = SCOPE_IDENTITY()) ORDER BY LastName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@AdditionalContactInfo" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="AdditionalContactInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AdditionalData" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="AdditionalData" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Top 200 ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate,AdditionalData FROM Person.Contact ORDER BY LastName</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Person].[Contact] SET [NameStyle] = @NameStyle, [Title] = @Title, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [Suffix] = @Suffix, [EmailAddress] = @EmailAddress, [EmailPromotion] = @EmailPromotion, [Phone] = @Phone, [PasswordHash] = @PasswordHash, [PasswordSalt] = @PasswordSalt, [AdditionalContactInfo] = @AdditionalContactInfo, [rowguid] = @rowguid, [ModifiedDate] = @ModifiedDate, [AdditionalData] = @AdditionalData WHERE (([ContactID] = @Original_ContactID) AND ([NameStyle] = @Original_NameStyle) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ([FirstName] = @Original_FirstName) AND ((@IsNull_MiddleName = 1 AND [MiddleName] IS NULL) OR ([MiddleName] = @Original_MiddleName)) AND ([LastName] = @Original_LastName) AND ((@IsNull_Suffix = 1 AND [Suffix] IS NULL) OR ([Suffix] = @Original_Suffix)) AND ((@IsNull_EmailAddress = 1 AND [EmailAddress] IS NULL) OR ([EmailAddress] = @Original_EmailAddress)) AND ([EmailPromotion] = @Original_EmailPromotion) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ([PasswordHash] = @Original_PasswordHash) AND ([PasswordSalt] = @Original_PasswordSalt) AND ([rowguid] = @Original_rowguid) AND ([ModifiedDate] = @Original_ModifiedDate));
SELECT TOP (200) ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate, AdditionalData FROM Person.Contact WHERE (ContactID = @ContactID) ORDER BY LastName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@AdditionalContactInfo" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="AdditionalContactInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AdditionalData" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="AdditionalData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ContactID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ContactID" ColumnName="ContactID" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ContactID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContactID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ContactID" DataSetColumn="ContactID" />
              <Mapping SourceColumn="NameStyle" DataSetColumn="NameStyle" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="MiddleName" DataSetColumn="MiddleName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Suffix" DataSetColumn="Suffix" />
              <Mapping SourceColumn="EmailAddress" DataSetColumn="EmailAddress" />
              <Mapping SourceColumn="EmailPromotion" DataSetColumn="EmailPromotion" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="PasswordHash" DataSetColumn="PasswordHash" />
              <Mapping SourceColumn="PasswordSalt" DataSetColumn="PasswordSalt" />
              <Mapping SourceColumn="AdditionalContactInfo" DataSetColumn="AdditionalContactInfo" />
              <Mapping SourceColumn="rowguid" DataSetColumn="rowguid" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="AdditionalData" DataSetColumn="AdditionalData" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="AdventureWorks_DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteContacts" Modifier="Public" Name="DeleteContacts" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteContacts">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [Person].[Contact] WHERE (([ContactID] = @Original_ContactID) AND ([NameStyle] = @Original_NameStyle) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ([FirstName] = @Original_FirstName) AND ((@IsNull_MiddleName = 1 AND [MiddleName] IS NULL) OR ([MiddleName] = @Original_MiddleName)) AND ([LastName] = @Original_LastName) AND ((@IsNull_Suffix = 1 AND [Suffix] IS NULL) OR ([Suffix] = @Original_Suffix)) AND ((@IsNull_EmailAddress = 1 AND [EmailAddress] IS NULL) OR ([EmailAddress] = @Original_EmailAddress)) AND ([EmailPromotion] = @Original_EmailPromotion) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ([PasswordHash] = @Original_PasswordHash) AND ([PasswordSalt] = @Original_PasswordSalt) AND ([rowguid] = @Original_rowguid) AND ([ModifiedDate] = @Original_ModifiedDate))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ContactID" ColumnName="ContactID" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ContactID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContactID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_NameStyle" ColumnName="NameStyle" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="NameStyle" DbType="Boolean" Direction="Input" ParameterName="@Original_NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_Title" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_Title" ColumnName="Title" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="nvarchar(8)" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_FirstName" ColumnName="FirstName" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_MiddleName" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_MiddleName" ColumnName="MiddleName" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@Original_MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_LastName" ColumnName="LastName" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_Suffix" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_Suffix" ColumnName="Suffix" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@Original_Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_EmailAddress" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_EmailAddress" ColumnName="EmailAddress" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EmailPromotion" ColumnName="EmailPromotion" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_Phone" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_Phone" ColumnName="Phone" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="Phone" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_PasswordHash" ColumnName="PasswordHash" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="varchar(128)" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="128" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_PasswordSalt" ColumnName="PasswordSalt" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_rowguid" ColumnName="rowguid" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Original_rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ModifiedDate" ColumnName="ModifiedDate" DataSourceName="[D:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS_DATA.MDF].Person.Contact" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Original_ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="AdventureWorks_DataConnectionString (Settings)" DbObjectName="Person.Contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByContactID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByContactID" GeneratorSourceName="FillByContactID" GetMethodModifier="Public" GetMethodName="GetDataByContactID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByContactID" UserSourceName="FillByContactID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AdditionalContactInfo, AdditionalData, ContactID, EmailAddress, EmailPromotion, FirstName, LastName, MiddleName, ModifiedDate, NameStyle, PasswordHash, PasswordSalt, Phone, Suffix, Title, rowguid FROM Person.Contact WHERE (ContactID = @contactID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="contactID" ColumnName="ContactID" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@contactID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContactID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="AdventureWorks_DataConnectionString (Settings)" DbObjectName="Person.Contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByModifiedDate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByModifiedDate" GeneratorSourceName="FillByModifiedDate" GetMethodModifier="Public" GetMethodName="GetDataByModifiedDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByModifiedDate" UserSourceName="FillByModifiedDate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AdditionalContactInfo, AdditionalData, ContactID, EmailAddress, EmailPromotion, FirstName, LastName, MiddleName, ModifiedDate, NameStyle, PasswordHash, PasswordSalt, Phone, Suffix, Title, rowguid FROM Person.Contact WHERE (ContactID IN (SELECT TOP (200) ContactID FROM Person.Contact AS Contact_1 ORDER BY Contact_1.LastName)) AND (ModifiedDate &gt;= @modifiedDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="modifiedDate" ColumnName="ModifiedDate" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@modifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="AdventureWorks_DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertContacts" Modifier="Public" Name="InsertContacts" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertContacts">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [Person].[Contact] ([NameStyle], [Title], [FirstName], [MiddleName], [LastName], [Suffix], [EmailAddress], [EmailPromotion], [Phone], [PasswordHash], [PasswordSalt], [AdditionalContactInfo], [rowguid], [ModifiedDate]) VALUES (@NameStyle, @Title, @FirstName, @MiddleName, @LastName, @Suffix, @EmailAddress, @EmailPromotion, @Phone, @PasswordHash, @PasswordSalt, @AdditionalContactInfo, @rowguid, @ModifiedDate);
SELECT ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate FROM Person.Contact WHERE (ContactID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="NameStyle" ColumnName="NameStyle" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="NameStyle" DbType="Boolean" Direction="Input" ParameterName="@NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Title" ColumnName="Title" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(8)" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FirstName" ColumnName="FirstName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MiddleName" ColumnName="MiddleName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="LastName" ColumnName="LastName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Suffix" ColumnName="Suffix" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="EmailAddress" ColumnName="EmailAddress" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EmailPromotion" ColumnName="EmailPromotion" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Phone" ColumnName="Phone" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Phone" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PasswordHash" ColumnName="PasswordHash" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="varchar(128)" DbType="AnsiString" Direction="Input" ParameterName="@PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="128" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PasswordSalt" ColumnName="PasswordSalt" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AdditionalContactInfo" ColumnName="AdditionalContactInfo" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="xml" DbType="Object" Direction="Input" ParameterName="@AdditionalContactInfo" Precision="0" ProviderType="Xml" Scale="0" Size="2147483647" SourceColumn="AdditionalContactInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="rowguid" ColumnName="rowguid" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ModifiedDate" ColumnName="ModifiedDate" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="AdventureWorks_DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateContacts" Modifier="Public" Name="UpdateContacts" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateContacts">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [Person].[Contact] SET [NameStyle] = @NameStyle, [Title] = @Title, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [Suffix] = @Suffix, [EmailAddress] = @EmailAddress, [EmailPromotion] = @EmailPromotion, [Phone] = @Phone, [PasswordHash] = @PasswordHash, [PasswordSalt] = @PasswordSalt, [AdditionalContactInfo] = @AdditionalContactInfo, [rowguid] = @rowguid, [ModifiedDate] = @ModifiedDate WHERE (([ContactID] = @Original_ContactID) AND ([NameStyle] = @Original_NameStyle) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ([FirstName] = @Original_FirstName) AND ((@IsNull_MiddleName = 1 AND [MiddleName] IS NULL) OR ([MiddleName] = @Original_MiddleName)) AND ([LastName] = @Original_LastName) AND ((@IsNull_Suffix = 1 AND [Suffix] IS NULL) OR ([Suffix] = @Original_Suffix)) AND ((@IsNull_EmailAddress = 1 AND [EmailAddress] IS NULL) OR ([EmailAddress] = @Original_EmailAddress)) AND ([EmailPromotion] = @Original_EmailPromotion) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ([PasswordHash] = @Original_PasswordHash) AND ([PasswordSalt] = @Original_PasswordSalt) AND ([rowguid] = @Original_rowguid) AND ([ModifiedDate] = @Original_ModifiedDate));
SELECT ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate FROM Person.Contact WHERE (ContactID = @ContactID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="NameStyle" ColumnName="NameStyle" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="NameStyle" DbType="Boolean" Direction="Input" ParameterName="@NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Title" ColumnName="Title" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(8)" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FirstName" ColumnName="FirstName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MiddleName" ColumnName="MiddleName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="LastName" ColumnName="LastName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Suffix" ColumnName="Suffix" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="EmailAddress" ColumnName="EmailAddress" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EmailPromotion" ColumnName="EmailPromotion" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Phone" ColumnName="Phone" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Phone" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PasswordHash" ColumnName="PasswordHash" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="varchar(128)" DbType="AnsiString" Direction="Input" ParameterName="@PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="128" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PasswordSalt" ColumnName="PasswordSalt" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AdditionalContactInfo" ColumnName="AdditionalContactInfo" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="xml" DbType="Object" Direction="Input" ParameterName="@AdditionalContactInfo" Precision="0" ProviderType="Xml" Scale="0" Size="2147483647" SourceColumn="AdditionalContactInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="rowguid" ColumnName="rowguid" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ModifiedDate" ColumnName="ModifiedDate" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ContactID" ColumnName="ContactID" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ContactID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContactID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_NameStyle" ColumnName="NameStyle" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="NameStyle" DbType="Boolean" Direction="Input" ParameterName="@Original_NameStyle" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="NameStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_Title" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_Title" ColumnName="Title" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(8)" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="8" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_FirstName" ColumnName="FirstName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_MiddleName" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName" Precision="0" Scale="0" Size="0" SourceColumn="MiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_MiddleName" ColumnName="MiddleName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@Original_MiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="MiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_LastName" ColumnName="LastName" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Name" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_Suffix" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix" Precision="0" Scale="0" Size="0" SourceColumn="Suffix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_Suffix" ColumnName="Suffix" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@Original_Suffix" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="Suffix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_EmailAddress" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailAddress" Precision="0" Scale="0" Size="0" SourceColumn="EmailAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_EmailAddress" ColumnName="EmailAddress" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Original_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="EmailAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EmailPromotion" ColumnName="EmailPromotion" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EmailPromotion" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EmailPromotion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_Phone" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_Phone" ColumnName="Phone" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="Phone" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_PasswordHash" ColumnName="PasswordHash" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="varchar(128)" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordHash" Precision="0" ProviderType="VarChar" Scale="0" Size="128" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_PasswordSalt" ColumnName="PasswordSalt" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_PasswordSalt" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="PasswordSalt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_rowguid" ColumnName="rowguid" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Original_rowguid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="rowguid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ModifiedDate" ColumnName="ModifiedDate" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Original_ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ContactID" ColumnName="ContactID" DataSourceName="[F:\CODE\STSSYNC\NORTHWINDPROVIDER\ADVENTUREWORKS.MDF].Person.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ContactID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ContactID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ContactsDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ContactsDS" msprop:Generator_DataSetName="ContactsDS" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Contact" msprop:Generator_UserTableName="Contact" msprop:Generator_RowDeletedName="ContactRowDeleted" msprop:Generator_RowChangedName="ContactRowChanged" msprop:Generator_RowClassName="ContactRow" msprop:Generator_RowChangingName="ContactRowChanging" msprop:Generator_RowEvArgName="ContactRowChangeEvent" msprop:Generator_RowEvHandlerName="ContactRowChangeEventHandler" msprop:Generator_TableClassName="ContactDataTable" msprop:Generator_TableVarName="tableContact" msprop:Generator_RowDeletingName="ContactRowDeleting" msprop:Generator_TablePropName="Contact">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ContactID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ContactID" msprop:Generator_ColumnPropNameInRow="ContactID" msprop:Generator_ColumnVarNameInTable="columnContactID" msprop:Generator_ColumnPropNameInTable="ContactIDColumn" type="xs:int" />
              <xs:element name="NameStyle" msprop:Generator_UserColumnName="NameStyle" msprop:Generator_ColumnPropNameInRow="NameStyle" msprop:Generator_ColumnVarNameInTable="columnNameStyle" msprop:Generator_ColumnPropNameInTable="NameStyleColumn" type="xs:boolean" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName" msprop:Generator_UserColumnName="MiddleName" msprop:Generator_ColumnPropNameInRow="MiddleName" msprop:Generator_ColumnVarNameInTable="columnMiddleName" msprop:Generator_ColumnPropNameInTable="MiddleNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Suffix" msprop:Generator_UserColumnName="Suffix" msprop:Generator_ColumnPropNameInRow="Suffix" msprop:Generator_ColumnVarNameInTable="columnSuffix" msprop:Generator_ColumnPropNameInTable="SuffixColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmailAddress" msprop:Generator_UserColumnName="EmailAddress" msprop:Generator_ColumnPropNameInRow="EmailAddress" msprop:Generator_ColumnVarNameInTable="columnEmailAddress" msprop:Generator_ColumnPropNameInTable="EmailAddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmailPromotion" msprop:Generator_UserColumnName="EmailPromotion" msprop:Generator_ColumnPropNameInRow="EmailPromotion" msprop:Generator_ColumnVarNameInTable="columnEmailPromotion" msprop:Generator_ColumnPropNameInTable="EmailPromotionColumn" type="xs:int" />
              <xs:element name="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PasswordHash" msprop:Generator_UserColumnName="PasswordHash" msprop:Generator_ColumnPropNameInRow="PasswordHash" msprop:Generator_ColumnVarNameInTable="columnPasswordHash" msprop:Generator_ColumnPropNameInTable="PasswordHashColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PasswordSalt" msprop:Generator_UserColumnName="PasswordSalt" msprop:Generator_ColumnPropNameInRow="PasswordSalt" msprop:Generator_ColumnVarNameInTable="columnPasswordSalt" msprop:Generator_ColumnPropNameInTable="PasswordSaltColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdditionalContactInfo" msprop:Generator_UserColumnName="AdditionalContactInfo" msprop:Generator_ColumnPropNameInRow="AdditionalContactInfo" msprop:Generator_ColumnVarNameInTable="columnAdditionalContactInfo" msprop:Generator_ColumnPropNameInTable="AdditionalContactInfoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="rowguid" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="rowguid" msprop:Generator_ColumnPropNameInRow="rowguid" msprop:Generator_ColumnVarNameInTable="columnrowguid" msprop:Generator_ColumnPropNameInTable="rowguidColumn" type="xs:string" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="AdditionalData" msprop:Generator_UserColumnName="AdditionalData" msprop:Generator_ColumnPropNameInRow="AdditionalData" msprop:Generator_ColumnVarNameInTable="columnAdditionalData" msprop:Generator_ColumnPropNameInTable="AdditionalDataColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Contact" />
      <xs:field xpath="mstns:ContactID" />
    </xs:unique>
  </xs:element>
</xs:schema>